FAQ汇萃
>> Oracle 专栏
>> 显示去年里数据库的每个月的空间增长情况 [查看别人的评论]
由 macro 发布于: 2001-03-03 09:25
set pagesize 50000
tti "Database growth per month for last year"
select to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024 "Growth in Meg"
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month')
/
tti off
Month Growth in Meg
--------- -------------
2000 12月 304.382813
2001 1月 105
|
